Search jobs > Houston, TX > Data analyst

Data Analyst

Diverse Lynx
Houston, TX, United States
Full-time

Job Description :

Overview of Work : Prepare data for ingestion to data warehouse through supporting data management, data mapping, and dataT modeling activities.

Provide oversight and help troubleshoot data quality and integrity

Technical Skills :

Knowledge of Data Modeling Patterns and Designs

Knowledge of Azure Data Lake and Azure SQL storage platforms

Knowledge of older storage platforms (MS SQL Server, Oracle, Teradata, ERP / SAP, etc.)

Understanding of older integration is beneficial (MS SQL Server, MS SSIS, IBM DataStage, etc.)

Awareness of Integration tools within Azure (Azure Data Factory (ADF), Azure Data Brick, Python, Spark SQL)

Awareness of Azure Synapse

Soft Skills :

Knowledge in data patterns (DIAL, OSDU, Microsoft Energy Design Patterns, etc.).

Ability to analyze various data sets, clarify data relationships, troubleshoot data issues and work with data architects / engineers to fix problems.

Ability to communicate with both business SMEs and development team members

Ability to develop, navigate, and comprehend mapping documents.

Experience with Azure DevOps (ADO) tool for work management.

Practitioner of Agile / SAFe practices.

Awareness of Data Modeling best practices (Star Schema, Time-Series, CI / CD, Cube).

Summary :

The main function of a Data Analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.

Job Responsibilities : Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Design, implement, automate and maintain large scale enterprise data ETL processes Modify existing databases and database management systems and / or direct programmers and analysts to make changes Test programs or databases, correct errors and make necessary modifications Skills : Experience with database technologies Knowledge of the ETL process Knowledge of at least one scripting language Strong written and oral communication skills Strong troubleshooting and problem solving skills Demonstrated history of success Desire to be working with data and helping businesses make better data driven decisions

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination.

All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role.

We promote and support a diverse workforce across all levels in the company.

13 days ago
Related jobs
Promoted
ENGIE North America Inc.
Houston, Texas

You hold a Bachelor's degree in information technology, or business intelligence were you studied data modeling, and data mining, Marketing degree or a related discipline where you gain knowledge in strategic marketing planning, pricing strategies, and data analytics. As our Customer Engagement Data...

Promoted
VirtualVocations
Houston, Texas

A company is looking for a Claims Data Analyst. ...

Crescent Realty
Houston, Texas

If you are a data-driven individual looking to kickstart your career in the Real Estate industry, we want to hear from you! Apply now to join Crescent Realty as a Data Analyst Intern and gain valuable experience in a dynamic and collaborative environment. Data Analyst Intern +...

Promoted
VirtualVocations
Houston, Texas

An organization is seeking an Organizing Analyst for a remote full-time position. ...

myGwork
Houston, Texas

Process vendor invoices verified against contractual obligations to verify accurate billing and allocations within Market Data Services inventory system (i. Provide a full range of MDS administrative support whilst maintaining all aspects of the market data inventory system to manage over $120m MDS ...

Promoted
VirtualVocations
Houston, Texas

A company is looking for a Data Analyst Consultant position. Key Responsibilities:Run loan level econometric cash flow models for subsidy re-estimatesSupport data collection, cleansing, and organizationCreate and troubleshoot SAS-based programs and assist with scenario analysisRequired Qualification...

Resource Data
Houston, Texas

Key Responsibilities Eliciting, maintaining, and translating business requirements from customer needs into technical requirements for custom software solutions Working with project teams to document standards, project deliverables, and requirements Collecting information through subject m...

Strategic Staffing Solutions
Houston, Texas

Applies understanding of data principles to develop and manage EMR data quality assurance reports, system audit tools, and to the development of products to meet global EMR user requirements. Under the supervision of the Team Lead, support and maintain EMR/medical database users. ...

TC Energy
Houston, Texas

As the Safety Data Analyst, you play a critical role in enhancing our organization's safety performance and risk management capabilities. Leveraging advanced data science techniques and emerging AI technologies, you derive actionable insights from safety data to support better decision-making and dr...

WAHVE
Houston, Texas
Remote

Build and maintain data warehouse, new reports, and ad hoc reports. Compile and prepare data for customer analysis. Ability to compile data results and author commentary on industry studies is a plus. ...