Data Developer, Gaithersburg

Our IT department is currently seeking an experienced Data Developer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions.

Be Ready To:

develop reliable, reusable, automated and streamlined ETL cod

analyze and organize raw data from multiple sources to produce requested or required data elements

design table structures and ETL to build performant data solutions that are scalable in a fast growing data ecosystem

create reconciliation procedures and data checks to ensure data quality

build in automated audit, balancing and controls

provide production support, including on-call rotation and technical assistance to end-user and IT staff

lead user requirements gathering and documentation designs

proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries

lead application and technical architecture analysis, design and implementation, and ensure BI product fulfills requirements

lead efforts with data management and database specialists to troubleshoot and report issues

design new reporting applications to ensure reporting requests can be supported by the underlying data source

adhere to all metadata management and data quality standards by leading quality management reviews

understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge

proactively identify, build and maintain relationships with business process owners and colleagues

identify changes in scope or work effort that could result in budgetary overrun or missing of delivery date, design and implement contingency

demonstrate expert problem solving capabilities

mentor development team members in design and development of BI solutions

Be Equipped With:

proven experience in designing and implementing ETL processes (preferred tools: IBM's DataStage, SQL, SAS, Python, Unix)

proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models

preferred five or more years experience with SQL, Data Modeling and Dimensional Modeling

experience with cloud data technologies/platforms (Azure/Snowflake preferred)

understanding of enterprise technical landscape (property and casualty insurance background a plus)

knowledge of developing BI dashboards and reports (preferred tools: IBM's Cognos, Microsoft's Power BI), including data quality scorecards and data lineage

experience with agile teams

strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills

ability to comprehend complex technical and logical concepts and adapt quickly to changes

ability to maintain own workflow and meet deadlines while managing parallel project deliverables with minimal direction

ability to create effective visual models to enable collective understanding of processes, data flow, user interaction and others as needed

prior reporting application support experience

track record of successfully architecting small, medium and enterprise-scale solutions

preferred three or more years of business requirements experience