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.