BI ETL Developer IV

Title

BI ETL Developer IV (Multiple Openings)

Stamford, CT

Serve as a technical ETL (Extract/Transform/Load) lead on large‑scale reporting projects and guide other collaborators effectively to project completion. Serve as a resident expert on cross‑functional Business Intelligence (BI) solutions. Ensure all team members incorporate architectural and organizational best practices when creating or enhancing BI solutions. Troubleshoot and triage BI tools, systems, and software issues in the production environment. Provide data model design for the development of cost‑effective BI solutions in a large‑scale cloud data warehouse environment, utilizing the tools and technologies supported by our platform.

Lead workstream/project for ETL and data model planning to accurately project scope and complexity and provide reliable estimates for level of effort including work from external stakeholders and horizontal teams (such as Shared Services, Architecture, Production Operations and vertical partners including Business Analysts and other Report Developers) to achieve business objectives. Utilize SQL for both declarative/procedural queries and data design language in a large‑scale warehouse environment.

Provide support and mentoring through example (e.g. code reviews, feature demos, technical challenges) to help ensure team members solve problems correctly, increase their skillsets and achieve their development goals. Ensure the durability, reliability and accuracy of our reporting products at all times. Ensure code is tuned for high performance and cost effectiveness to minimize costs and keep reports highly responsive in our self‑service Micro Strategy platform.

• Bachelor's degree in Computer Science, Information Systems, Business Management, or a related field.
• 10 years of experience implementing SQL query and procedure design within large‑scale data warehouse environments.
• 10 years of experience utilizing ETL design for data ingestion, data translation, and data normalization to extract source data and load into reporting models.
• 10 years of experience utilizing business requirements to design effective and efficient data models for self‑service reporting.
• 10 years of experience delivering reporting solutions in a Business Intelligence or Information Technology environment.
• 2 years of experience operating with MPP (massively parallel) Cloud databases such as Teradata, Exadata, Snowflake or Redshift.
• In lieu of a Bachelor's degree, a Master's degree in Computer Science, Information Systems, Business Management, or a related field and 7 years of experience (including at least two years in the above) is acceptable.
• Hybrid arrangement is available.

A comprehensive pay and benefits package that rewards employees for their contributions to our success, supporting all aspects of well‑being at every stage of life.

A qualified applicant's criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances. Spectrum is an Equal Opportunity Employer, including job seekers with disabilities and veterans.