Data Warehouse Analyst

Job Description – Data Warehouse Analyst (SQL, Informatica)

Location: Uncasville, CT (Hybrid)
Job Type: Full-Time (FTE)
Experience: 2–10 Years

• Gather business requirements and translate them into technical data warehouse solutions.
• Design, develop, and maintain ETL processes using Informatica and SQL.
• Build and support data warehouse structures, data models, and database views.
• Monitor and validate data loads to ensure data accuracy, quality, and integrity.
• Develop and maintain BI reports, dashboards, and data visualizations.
• Troubleshoot and provide Level III support for data warehouse and BI applications.
• Create and maintain technical documentation, including data dictionaries and system documentation.
• Collaborate with cross-functional teams to deliver reporting and analytics solutions.
• Optimize SQL queries and ETL processes for performance and scalability.
• Support mission-critical applications in a 24x7 enterprise environment and participate in on-call support.

• Strong experience with SQL and Informatica.
• Hands-on experience with ETL/ELT, Data Warehousing, and Data Modeling.
• Experience with BI tools such as Power BI, Tableau, Cognos, or Snowflake.
• Strong understanding of relational databases and data analysis.
• Excellent analytical, troubleshooting, and communication skills.
• Bachelor''s degree in Computer Science, Information Systems, Engineering, or a related field.

• Experience with cloud data platforms.
• Knowledge of Python or Shell scripting.
• Experience in regulated industries such as Healthcare, Gaming, or Finance.
• Familiarity with Data Governance and Data Quality frameworks.