SQL Data Analyst

---

Job description

Our client a leading asset management firm, located in New York City is looking to hire a SQL Data Analyst. As a Data Analyst, your primary focus will be to develop and execute a comprehensive data strategy, establish robust data governance practices, and ensure efficient reporting solutions within our organization. You will play a pivotal role in shaping the data landscape, enabling data-driven decision-making, and optimizing data assets to drive business success. You will also work closely with the business to understand their data requirements and deliver solutions to support their needs. This is a Full Time Position. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor currently. Qualified candidates should send their resumes (Word Format) along with salary expectations to .

MUST HAVE AZURE SSIS (AZURE SYNAPSE)

RESPONSIBILITIES

Design and implement a forward-looking data strategy that aligns with the organization's business objectives, incorporating industry best practices and emerging data technologies.

Define and maintain a scalable, efficient, and flexible data architecture that accommodates diverse data sources and formats, while enabling seamless data integration and access. Work closely with business stakeholders to align architecture with their requirements.

Design and develop robust ETL (Extract, Transform, Load) processes to efficiently move, cleanse, and transform data from various sources into a central data repository, meeting business needs.

Implement and manage master data management solutions to ensure data consistency, accuracy, and reliability across the organization, in collaboration with various departments.

Collaborate with business stakeholders to define reporting requirements and deliver business intelligence and reporting solutions that provide actionable insights. Work closely with various departments to understand their reporting needs.

Establish data quality standards, conduct data profiling, and implement data quality improvement processes to maintain data integrity, with consideration for business-specific data quality requirements.

Create and maintain comprehensive documentation of data assets, data flows, and data definitions, making it accessible to relevant business teams.

Continuously assess emerging data technologies and tools to keep the organization up-to-date and competitive.

Design and implement databases to reflect new and existing business requirements.

Evaluate current data designs and databases to determine needed, upgrades and improvements.

Design and automate various internal and external reports using SSRS, InDesign and Power BI.

Communicate with many different company stakeholders to assess needs and goals.

Interpret functional and business requirements, design and implement solutions and architecture suited to our current business model and enhance them.

QUALIFICATIONS

Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.

2+ years working experience in IT at Financial Institutions.

3+ years full stack development of enterprise applications and database solutions.

Hands on experience with SQL Server, Azure, SSRS, Power BI.

Experience in data architecture, data strategy, data governance, and reporting.

In-depth knowledge of database management systems, data modeling, ETL processes, and reporting tools

Excellent communication and interpersonal skills for collaboration with cross-functional teams and stakeholders

Knowledge of industry best practices and data management trends

Skills and Abilities:

Knowledge of business domain is recommended.

Proficiency in Azure data services and technologies.

Strong understanding of data architecture, data modeling, and data governance principles.

Knowledge of ETL processes and tools, particularly within the Azure ecosystem.

Experience with master data management (MDM) and data quality management.

Expertise in data reporting and analytics tools, especially those integrated with Azure.

In-depth knowledge of data security and compliance, including Azure security practices.

Excellent documentation and communication skills.

Expertise in T-SQL and SQL Server Data Management Services (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)Solid knowledge of T-SQL (SQL Server) which includes stored procedures, UDF's and query optimization.

Solid knowledge of ETL, SSRS and Power BI.

Experience in T-SQL, SSRS, Power BI and SQL Server database management system.

Good understanding of Azure environment and DevOps.

InDesign Automation a plus.

Salary 100-120k

<!– job description page –>