SQLSSAS Developer
SQLSSAS Developer
Posted on :
08-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Posted on :
08-10-2024
Job Description
SQL/SSAS Developer
612 months (contract to hire)
Houston TX (Hybrid)
Job Summary:
This person will be responsible for performing the data analysis and profiling necessary to provide direction standards and implementation of data management solutions associated with data ingestion transformation integration and analytics. They will engage in full stack Microsoft BI development activities to deploy usable and measurable projects meeting business needs leveraging tools such as SSIS SSAS stored procedures and Power BI.
Must Have:
- SQL Development
- SSAS
- PowerBI
- DAX
VS or Visual Studio (nice to have)
Job Requirements:
Job Requirements:
- Resolve dead locks issues with the Databases/Servers on a realtime basis.
- Formulate procedures for data extraction transformation and integration of data.
- Create SSIS packages that generates transition of care for tailor plan and standard plan claim files.
- Pull data from Excelys and create different configuration and inventory SAS reports.
- Design Microsoft Power BI dashboards and manage power BI gateways with a focus on usability performance flexibility testability and standardization.
- Create scripts using DAX functions in Power BI Desktop.
- Develop measures using DAX language.
- Develop dashboards analytical reports KPIs based on business requirements.
- Create complex Stored Procedures Triggers Functions (UDF) Indexes Tables Views and other TSQL code and SQL joins for applications following SQL code standards.
- Perform efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
- Create Stored Procedures to transform the Data and worked extensively in TSQL for various needs of the transformations while loading the data.
- Document all work and process of integration and reporting services for further references.
- Create views to display required information on user interface and triggers to validate consistent data entry into the database.
Preferred Experience:
- Minimum seven (7) years experience in a multidisciplined IT environment with strong expertise in data analysis data modeling data governance and involvement in enterprise architecture.
- Minimum of five (5) years experience handson data profiling and performance tuning databases and data marts with Oracle and / or SQL Server.
- Experience with performance improvement using Azure and/or onpremise Microsoft technologies.
- Experience taking a lead role in architecting designing and developing solutions exceeding business expectations.
- Knowledge of interpreting business processes and requirements and translating them into logical and physical data models adhering to documented standards and best practices.
- Excellent problem solving and communication skills with experience in interacting with business and technical teams at all levels.
Work Schedule:
- Hybrid 3 days onsite (TuesThurs) 2 days remote (Mon/Fri)
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
