Business Intelligence Developer with ETL Experience

Job Description

Job Description

Business Intelligence Developer with Extract Transform and Load Experience  

My name is Bill Stevens, and I have a new full time Business Intelligence Developer opportunity available for a major firm in Greenwich, Connecticut that could be of interest to you, please review my specification below. The work week schedule will be hybrid, three days a week in the office and two days remote.

The ideal candidate should also possess a green card or be of citizenship. No Visa entanglements and no H1-B holding company submittals.  

This position will be paying a competitive fulltime salary in the range of $125,000 - $135,000 plus a comprehensive benefits package.

Responsibilities:

Normalize data into cohesive and effective models that embody high levels of sophistication, curation, and standardization.

Troubleshoot and triage BI tools, systems, and software issues in the production environment.

Support escalated data integrity issues and recommend remediation solutions. Develop thorough and thoughtful documentation for all technical aspects of reports, procedures, data models and design elements included in reporting solutions.

Perform SQL query design in large-scale data warehouse environments; and ETL design for implementing data ingestion, translation and normalization.

Design data models for reporting.

Deliver reporting solutions in an IT and Business Intelligence (BI) environment. Utilize massively parallel databases including Teradata, Exadata, Snowflake, or Redshift.

Translate complex business processes to implement technical solutions of a cross-functional nature that drive innovative reporting products.

Provide data model design for the development of cost-effective BI solutions in a large-scale cloud data warehouse environment.

Communicate effectively with horizontal teams including Shared Services, Architecture, Production Operations and vertical partners to achieve business objectives. Participate in workstream/project planning to accurately project scope and complexity and provide reliable estimates for level of effort including work from external stakeholders and horizontal teams.

Participate in peer review of new and updated procedures and conduct independent testing and resolution.

Ensure the durability, reliability and accuracy of reporting products.

Utilize SQL for declarative/procedural queries and data design language in a large-scale warehouse environment with a self-service MicroStrategy platform.

Support all development standards, ensuring business continuity through high quality, durable code with minimal technical debt and excellent maintainability.

Ensure processes and data models are consistent with Data Governance standards.

Perform data conversions, imports and exports of data within and between internal and external software, from a wide variety of disparate source platforms.

Education:

Master’s degree in Computer Science, Information Technology, or a related field.

Five years of experience in: SQL query design in large-scale data warehouse environments; ETL design for implementing data ingestion, translation and normalization; designing data models for reporting; and delivering reporting solutions in an IT or Business Intelligence (BI) environment.

Two years of experience in massively parallel databases including at least one of the following: Teradata, Exadata, Snowflake, or Redshift.

OR

Bachelor's degree in Computer Science, Information Technology, or a related field.

Seven years of experience in: SQL query design in large-scale data warehouse environments; ETL design for implementing data ingestion, translation and normalization; designing data models for reporting; and delivering reporting solutions in an IT or Business Intelligence (BI) environment.

Two years of experience in massively parallel databases including at least one of the following: Teradata, Exadata, Snowflake, or Redshift.

The interview process will include an initial phone or virtual interview screening.

Please let me know your interest in this position, availability to interview and start for this position along with a copy of your recent resume.