What are the responsibilities and job description for the IT Specialist - Data Warhousing position at MVP Consulting Plus?
HBITS: HBITS-08-15019
Expert, IT Specialist
30 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week in Albany, NY
--- Project Description ---
We are looking for a technical expert to build data workflows, validate
financial data, and enforce data quality. You will actively engineer data
solutions, automate manual reporting, and query datasets to support
Data Governance and business stakeholders.
--- Day-to-Day Tasks ---
1. Translate complex business requirements from data stakeholders into
technical specifications for data pipelines and automated workflows.
2. Build and maintain data warehousing workflows and data pipelines
using SQL and cloud database tools.
3. Compile, compute, analyze and validate data using advanced
statistical formulas and model calculations.
4. Elaborate high-level policies and business needs into technical
requirements (user stories/system use cases) to guide platform
implementation.
5. Execute data profiling, build exception reports, and manage
metadata/lineage using data platforms.
6. Use programming language (Python/VBA/R) to automate data
ingestion and reporting processes.
--- Required Qualifications ---
84 Months experience in Data warehousing, profiling, governance,modeling
or data quality assurance for Financial Reporting.
84 Months of Experience in SQL, Oracle and other Database Management
Systems, including querying. Provide example(s) of independently problem
solving and support to internal data stakeholders that resolved data issues in
real time.
84 Months of Experience with data visualization, dashboarding, using tools
like Tableau, Business Objects, Power BI.
36 Months of Experience in cloud based data platforms, like Snowflake or
Azure
Bachelor's Degree
84 Months of Experience in automating data tasks like ingestion, mapping,
reporting, testing, validation, analysis, using programming languages such as
SAS, Python, R, or Excel VBA.
84 Months of Experience in providing governance, and technical support.
Liaise with data vendors/solution providers, internal stakeholders, other
technology teams (Data Architecture, Project Management team) to support
data strategy and initiatives. Translate business requirements into technical
specifications.
84 Months of Experience with Data Cataloging Platforms (e.g., Informatica,
Collibra, Alation) to execute data profiling, data quality, data mapping and
manage lineage.
84 Months of experience in writing documentation to capture requirements
and logic, and encourage adoption of data catalog, data quality and data
management processes and other data related initiatives (i.e., data
platform/integration solutions).
MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.
Expert, IT Specialist
30 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week in Albany, NY
--- Project Description ---
We are looking for a technical expert to build data workflows, validate
financial data, and enforce data quality. You will actively engineer data
solutions, automate manual reporting, and query datasets to support
Data Governance and business stakeholders.
--- Day-to-Day Tasks ---
1. Translate complex business requirements from data stakeholders into
technical specifications for data pipelines and automated workflows.
2. Build and maintain data warehousing workflows and data pipelines
using SQL and cloud database tools.
3. Compile, compute, analyze and validate data using advanced
statistical formulas and model calculations.
4. Elaborate high-level policies and business needs into technical
requirements (user stories/system use cases) to guide platform
implementation.
5. Execute data profiling, build exception reports, and manage
metadata/lineage using data platforms.
6. Use programming language (Python/VBA/R) to automate data
ingestion and reporting processes.
--- Required Qualifications ---
84 Months experience in Data warehousing, profiling, governance,modeling
or data quality assurance for Financial Reporting.
84 Months of Experience in SQL, Oracle and other Database Management
Systems, including querying. Provide example(s) of independently problem
solving and support to internal data stakeholders that resolved data issues in
real time.
84 Months of Experience with data visualization, dashboarding, using tools
like Tableau, Business Objects, Power BI.
36 Months of Experience in cloud based data platforms, like Snowflake or
Azure
Bachelor's Degree
84 Months of Experience in automating data tasks like ingestion, mapping,
reporting, testing, validation, analysis, using programming languages such as
SAS, Python, R, or Excel VBA.
84 Months of Experience in providing governance, and technical support.
Liaise with data vendors/solution providers, internal stakeholders, other
technology teams (Data Architecture, Project Management team) to support
data strategy and initiatives. Translate business requirements into technical
specifications.
84 Months of Experience with Data Cataloging Platforms (e.g., Informatica,
Collibra, Alation) to execute data profiling, data quality, data mapping and
manage lineage.
84 Months of experience in writing documentation to capture requirements
and logic, and encourage adoption of data catalog, data quality and data
management processes and other data related initiatives (i.e., data
platform/integration solutions).
MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.