Business Analyst - Expertise in Data Warehousing Concepts

Title: Technical Business Analyst

Location: Dallas, TX (Onsite with Hybrid)

Long Term Contract

Start: ASAP

Final Interview round will be F2F

Education:

• Bachelor’s degree in computer science, Information Technology, Business Administration, or a related field.
• Advanced certifications in data analytics and business analysis are a plus.

Technical Skills:

Data Warehouse Expertise:

• In-depth knowledge of data warehouse core concepts, including data architecture, data integration, and data governance.
• Strong understanding of logical data modeling and relational database design.

Query Writing:

• Proficiency in writing SQL queries for data extraction, analysis, and reporting.

Azure Services:

• Experience working with Azure cloud services, including (preferred but not mandatory):
• Azure SQL Server
• Azure Data Factory (ADF)
• Azure Databricks.

Tools & Technologies:

• Familiarity with ETL tools like SSIS.
• Exposure to data visualization tools such as Power BI or Tableau.

Industry Knowledge:

• Prior experience in the financial industry is a strong advantage, with knowledge of financial data structures and reporting requirements.

Soft Skills:

• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Excellent communication and interpersonal skills to collaborate effectively with technical teams and business stakeholders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Attention to detail and a commitment to delivering high-quality work.

Responsibilities:

Requirements Gathering:

• Collaborate with business stakeholders to gather and document requirements for data engineering projects.
• Translate business needs into technical specifications for data pipelines, data models, and reporting solutions.

Data Analysis:

• Analyze large datasets to identify trends, patterns, and insights that support business decision-making.
• Write and optimize SQL queries to extract and manipulate data for analysis.

Data Modeling:

• Design and maintain logical data models to support data warehouse architecture and reporting needs.

Collaboration with Data Engineers:

• Work closely with senior and junior data engineers to ensure data pipelines and ETL processes align with business requirements.
• Provide input on database schema design and optimization.

Azure Services Utilization:

• Leverage Azure cloud services to support data integration, storage, and analytics workflows.
• Collaborate on projects involving Azure Data Factory, Azure SQL Server, and Databricks.

Documentation:

• Create and maintain comprehensive documentation for business requirements, data models, and technical workflows.

Financial Industry Insights:

• Apply knowledge of financial data structures and reporting standards to ensure compliance and accuracy in data solutions.

Technology Evaluation:

• Stay updated with emerging technologies and best practices in data analysis and business intelligence.
• Recommend new tools and technologies to improve efficiency and scalability.