Job description

Job Code : 85823Y0543 Client: City of NY - DoITT Job Title: Senior Analytics Developer Location: Brooklyn, NY 11201 Duration: 10+ Months Rate: $113/hr c2c This is replacement position Job Description: 2 MTC Brooklyn/Remote an option with onsite visits for critical meetings as needed This is with the client NYC OTI. SCOPE OF SERVICES Responsibilities: • Develop and maintain highly efficient and interactive reports, dashboards, and data models to meet business requirements. • Collaborate with data scientists and business stakeholders to understand data analysis needs and translate them into technical requirements. • Design and implement data engineering pipelines to extract, transform, and load data from various sources into the analytics platform. • Perform data validation, cleansing, and transformation to ensure accuracy and consistency. • Optimize database queries and data retrieval processes to enhance performance and scalability. • Conduct data profiling and analysis to identify data quality issues and provide recommendations for improvement. • Stay up to date with industry best practices and emerging trends in analytics, data engineering, and visualization tools. MANDATORY SKILLS/EXPERIENCE • 12+ years of experience as an Analytics Developer, Data Engineer, or similar role, with a focus on developing reports, dashboards, and data models. • Strong experience designing and implementing data models and schemas in Snowflake. • Define Snowflake databases objects to support efficient data storage and retrieval. • Expertise with data visualization tools such as Power BI, Looker, Tableau, or similar. • Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL, Oracle). • Proficiency in data modeling concepts and techniques (e.g., dimensional modeling, star schema). • Solid understanding of data engineering principles and experience with data integration and ETL processes. • Familiarity with cloud platforms, preferably Azure, and experience with integration tools like IICS (Informatica Intelligent Cloud Services). • Excellent problem-solving skills and attention to detail. • Strong communication and collaboration skills to work effectively in cross-functional teams. DESIRABLE SKILLS/EXPERIENCE: • Proficiency in programming languages such as Python, R, or Java. • Familiarity with big data technologies (e.g., Hadoop, Spark) is a plus. • Experience with data integration tools such as Informatica Intelligent Cloud Services and Mulesoft. • Experience using Azure services for Security, Blob Storage, Data Lake, Databricks, Data Factory etc. • Experience with Azure Monitoring services • MS Certified Azure Solutions Architect Expert or a Snowpro Certification or a similar one

Requirements