| Senior BI Developer at Irving, Texas, USA |
| Email: [email protected] |
| From: Ravina, Vyze Inc [email protected] Reply to: [email protected] Job Description - They do have light onsite requirements of 2-days a week / every 2-weeks so these resources MUST be local to the Dallas area CURRENTLY. The final interview is an ONSITE INTERVIEW and they will have to complete a TECHNICAL ASSESSMENT! It is a 3-step interview process (that I detailed out below in blue highlight). Make sure CNs know ALL of this and wont fight this process!! Senior BI Developer (SQL BI / PowerBI) Location: Irving, TX 75039 (2-days onsite [M / T] every other week) (must be locals or under 50 miles) Residency: Citizens or Green Cards ONLY Interview Process Phone Prescreen / Online Assessment (I am not sure what this assessment is but I am trying to find out more details) Interviewer: HR Director Teams Video Interview (2-Panel) Interviewers: CIO and Senior BI / Accounting Development Manager Final ONSITE Interview / Technical Assessment (again, I am trying to find out more about this tech assessment but nothing more to add currently) Interviewers: BI Manager | Senior BI / Accounting Development Manager | HR Director JOB SUMMARY The Senior BI Developer (SQL BI / PowerBI) will be responsible for the current / future data warehouse, BI solutions, and data migration strategies. The Senior BI Developer (SQL BI / PowerBI) will design database architectures, data warehouses, data migrations, data marts, BI packages, and implement user reporting solutions. The Senior BI Developer (SQL BI / PowerBI) must possess a strong understanding of database methodology, data analysis, advanced SQL queries, ETL, and business intelligence applications. Implement New BI / Data Warehouse Requirements SQL / ETL / BI Tools / Database Development / Reporting Interface with Customers / Technical Leaders Identify Scope / Vet Requirements / Identify Effective Reporting Strategies / Identify Best Data Sources for Reach Report Field / Identify Risks and Constraints / Design Reporting Formats, etc. Lead Internal Business Partner / External Third Party Team Meetings Develop / Implement / Maintain ETL Solutions Bringing New Data into Data Warehouse Develop Optimized Database Design / Achieving Acceptable Performance Tuning Views / Indexes for Proper Response Time, etc. Develop New Capabilities / Architectures that Capitalize on Client Portal Development / Ad-Hoc BI Capabilities Collaborate with Business Analysts / Data Engineers Understand Data Requirements / Design ETL Solutions Respond to Ad-Hoc Query Requests from Product / Vendor and Professional Services / Finance Departments Perform Full Lifecycle Data Warehouse / ETL / Business Intelligence Solution Development / Maintenance Perform Data Analysis Determine Root Cause of Data Integrity / Quality Issues Identified via QA / Business Report Owners, etc. | Analyzing Data Sets (advanced) Provide Guidance / Recommendations on BI Reporting Packages Adjusting Systems / Processes to Prevent Issue Reoccurrence, etc. MS SQL BI Stack (expert) SSRS (Reporting Services) / SSIS (Integrated Service) / SSAS (Analysis Services) Data Warehouse Solution Implementation Developing SSAS / MDX (hands-on) for Implementations Experience Supporting Month End Financial Reporting Process / Business Processes / Technologies Effectively Communicating / Presenting to All Levels of Business Explaining Complex Issues / Concepts in Simple / Understandable Language Analyze / Resolve Complex Technical Problems Data Load Issues / System Response Time / Business Rule Conflicts, etc. Expertise in Identification of Business / Data Requirements Converting into Conceptual / Logical Data Models JOB REQUIREMENTS Senior BI Developer (SQL BI / PowerBI) (5+ years) SSIS / SSRS / SSAS (MDX) / PowerBI SQL Server Complex T-SQL Querying / Stored Procs / Functions / Triggers / Views, etc. T-SQL Querying (hands-on / advanced) Writing Complex T-SQL / Expertise Optimizing T-SQL for Performance and Efficiency SSIS (Integrated Services) Design / Develop / Maintain Packages to ETL Data from Various Sources | Optimize Packages for Performance / Scalability | Troubleshoot / Resolve Data Integration Process Issues SSAS (Analysis Services) Design / Develop Cubes / Data Source Views / Named Queries / Dimensions / Deploying SSAS Projects | Hands-on MDX Query Development to Create / Customize Cubes PowerBI / SSRS (Reporting Services) PowerBI Development / Data Modeling / DAX Calculations / PowerQuery | Design / Map Data Models to Shift Raw Data into Meaningful Insights | Build Interactive / Visually Appealing PowerBI Dashboards / Reports | Maintain SSRS / PowerBI Reports / Dashboards | Write Data-Driven SSRS Reports | Design / Develop New SSRS Reports | Study / Analyze Understand Business Requirements in Context to Business Intelligence Data Modeling Logical / Physical / Conceptual Data Modeling (hands-on) | Designing / Mapping Data Models Dimensional Data Modeling / Star / Snowflake Schema Experience Database Design Principles / Performance Tuning / Index Strategies / Query Optimization Backup and Recovery / HA Solutions / Security Measures Keywords: quality analyst access management business intelligence active directory information technology microsoft Texas Senior BI Developer [email protected] |
| [email protected] View all |
| Tue Aug 27 00:02:00 UTC 2024 |