The role requires migrating existing client data warehouses from SQL Server to AWS Aurora, remapping reporting layers, and defining technical specifications for reporting requirements. Collaboration with users, promotion of best practices, and post-deployment support are also key responsibilities.
Company Description
Comtech is a woman-owned small business founded in 1998 and headquartered in Reston, VA. We offer IT solutions across the disciplines of program/project management, applications development, infrastructure, Cyber security, and enterprise content/data management services. We have developed our methodologies and processes based on the IT Infrastructure Library (ITIL) v.3 Framework across enterprise infrastructure operations. These methodologies and processes are reinforced through our organization’s externally accredited certifications, which include ISO 9001:2008 Quality Management System (QMS), ISO/IEC 20000-1:2011 IT Service Management Systems (SMS, corporate ITIL certification), ISO 27001:2005 Information Security Management System (ISMS), and CMMI-DEV Level 3"
Job DescriptionJob description:
- Migrate existing client warehouse(ODS & DM) from SQL server to AWS Aurora. This involves modifying the ETLs on Informatica Cloud and reconfiguring them to point to AWS Aurora DB. Remap existing BI layer to interact with the updated DB
- Require to remap reporting layer (Microstrategy and SQL reports) to point from SQL server to AWS Aurora
- Work with users and business SMEs to define technical specifications to develop reporting requirements, and technical documentation
- Promote and apply reporting best practices
- Develop/Modify Mappings in Microstrategy and SQL reportings
- Work with business analysts and process owners on the development of test cases and scripts
- Post deployment support and defect resolutions
- Experience with Agile/Scrum methodology
- Excellent oral, written communication and presentation skills
- Strong teamwork and problem solving abilities.
- 6+ years in Business Intelligence
- 5+ years of MicroStrategy Platform experience, including: Advanced Analytics Reports, Visual Insight Dashboards and Report Services Document creation and experience in administration too
- Fluent in SQL and able to read and write complex queries, views and stored procedures
- Experience in core Business Intelligence/ Data warehousing technology: RDBMS, Web, Client/ Server, OLAP, etc
- Experience with big data environments (Hadoop, Spark, Cassandra, etc.)
- Experience working with capturing reporting on Current and Historical Data
- Experience working with Transformations, Complex reports, Report Services Documents (Dashboards), Rolling Metrics, Nested Metrics, Relationship Filters, VLDB Properties (multi-pass sql, hints, etc)
- 3+ years in SQL reporting services
**Please share me your updated word copy of Resume.
**I Appreciate, if you can refer someone who is looking for this position.
Contact:
Nayan Hazare
IT Recruiter at Comtech LLC
Call- 703-962-6656
nhazare@ comtechllc.com
Similar Jobs
Information Technology • Software
The Microstrategy Lead role involves leading the development of metrics, reports, dashboards, and cubes in Microstrategy, along with mentoring a team at the Architect level.
Top Skills:
MicrostrategySQL
Information Technology • Consulting
The role is focused on leading a team in architecting and developing Microstrategy solutions, including reports, metrics, and dashboards, requiring advanced SQL skills.
Top Skills:
MicrostrategySQL
Information Technology • Software
The Technology Lead MicroStrategy will develop reports and dashboards, write SQL queries, partner with business stakeholders, and visualize data using MicroStrategy.
Top Skills:
Etl ToolsMicrostrategyPentahoSQLTableauTalend
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
