• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 29th Dec 2023

Must-Have

·         5+ years of expert TSQL/Procedural language and SSIS experience

·         Strong SQL experience, specifically SQL Server 2012.

·         Knowledge of data governance standards.

·         Advance TSQL coding a must

·         Hands on Dimensional Modeling

·         Hands on data transformation with SSIS and SQL Agent for automation and scheduling

·         Good understanding of Data warehouse concepts.

·         Azure working knowledge, don't need to be expert

·         Tableau knowledge is good to have

 

Job Responsibilities

·         Defines, develops, and implements automation of reports, processes, and interfaces.

·         Designs and develops models to improve financial analysis and to project financial impact of business changes.

·         Interprets and translates accounting and finance business needs into effective applications and operational requirements to assist IT staff with implementation of finance and accounting system solutions.

·         Works with IT and Finance to perform testing and facilitate implementation of data warehouses.

·         Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.

·         Understands and compiles accurate data to present reports and assesses data quality.

·         Applies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, and predictive analytics to deliver actionable business insights based on large-scale data.

·         Defines, captures, enriches, explores and preps data to support desired metrics monitoring and reports.

·         Troubleshoots and resolves problems related to accounting and finance systems and applications.

 

Skills:

·         Extensive knowledge of SQL

·         SQL Server Management Studio experience

·         Extensive knowledge of complex data models

·         Strong data analysis/mining experience

·         Strong data validation skills

·         Strong Experience with ETL tools

·         Driving curiosity and attention to detail

Reporting

·         Provides thorough, visible, rigorous and transparent data reports and analysis.

·         Tracks trends and provides recommendations for solutions based on findings.

·         Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods for different audiences.

·         Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk, and control indicators across agency divisions and departments.