Overview
On Site
Contract - W2
Skills
IT Consulting
Business Intelligence
Management
Data Structure
Data Modeling
Visualization
KPI
Data Extraction
Analytical Skill
Optimization
Communication
Relationship Management
Durable Skills
Dimensional Modeling
DAX
Modeling
Enterprise Resource Planning
Database
PL/SQL
Transact-SQL
Query Optimization
Extract
Transform
Load
Data Integration
Pivot Table
Data Governance
Data Validation
Cloud Computing
Data Security
Scripting
Python
Windows PowerShell
Data Marts
Analytics
Dashboard
Microsoft Power BI
Usability
Collaboration
Specification Gathering
Oracle EBS
Maximo
Data Warehouse
SQL
Stored Procedures
Oracle
Microsoft SQL Server
Data Analysis
Microsoft Excel
Data Quality
Performance Tuning
Customer Service
Billing
Reporting
Law
Job Details
- JOB-7407
- Systems Programmer
- Las Vegas, NV
- Contract
- Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently seeking a Systems Programmer to join our team.
QUALIFICATIONS- Minimum of five (5) years of experience in implementing Data Warehouses and providing Business Intelligence consulting services.
- Advanced SQL development experience with Oracle and Microsoft SQL Server.
- Direct experience with Oracle enterprise systems such as Oracle E-Business Suite and Oracle Customer Care and Billing, including data structures and integration.
- Extensive knowledge of Power BI development, including DAX, data modeling, and visualization standards.
- Capable of designing and implementing complex data models in Power BI.
- Skilled in building dashboards, KPIs, and drill-through reports using DAX and Power Query.
- Experienced in optimizing large datasets and applying row-level security.
- Experienced in data extraction, transformation, and loading using CData Sync.
- Track record of designing and developing subject-area DataMarts for analytical purposes.
- Proficient in data analysis using Excel, including pivot tables, complex formulas, and modeling techniques.
- Capable of independently delivering solutions through design, development, and optimization.
- Able to operate independently in consulting projects while effectively engaging with stakeholders and team members.
- Strong communication abilities and stakeholder relationship management.
CORE SKILLS- Data Warehousing: Design, ETL, dimensional modeling, and DataMart development.
- Power BI: Expert in DAX, Power Query, modeling, security, and performance optimization.
- ERP Systems: Knowledge of data models and reporting in Oracle E-Business Suite and Oracle Customer Care and Billing.
- Databases: Proficient in Oracle SQL, PL/SQL, SQL Server T-SQL, including query tuning and indexing.
- ETL / Data Integration: Skilled in tools such as CData Sync.
- Excel Analysis: Advanced use of pivot tables, formulas, lookups, and Power Pivot.
- Data Governance: Experience in data validation, cleansing, quality checks, and reconciliation.
PREFERRED / NICE-TO-HAVE- Familiarity with cloud platform integrations.
- Understanding of data security practices.
- Basic knowledge of automation scripting (Python, PowerShell).
KEY RESPONSIBILITIES- Lead the design, development, and implementation of enterprise Data Warehouse solutions.
- Architect and develop DataMarts to support business reporting and analytics.
- Build, optimize, and deliver reports and dashboards in Power BI, ensuring accuracy and usability.
- Collaborate with business stakeholders to gather requirements and translate them into technical specifications.
- Analyze and integrate data from Enterprise systems (Oracle E-Business Suite, Oracle Customer Care and Billing, IBM Maximo etc.,) into the Data Warehouse.
- Develop and optimize complex SQL queries and stored procedures in Oracle and Microsoft SQL Server.
- Conduct advanced data analysis in Excel, providing actionable insights to business users.
- Ensure data quality, integrity, and performance optimization across systems.
- Provide subject matter expertise in customer care and billing data models and reporting.
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.